const userSQL = {
    queryAll: 'SELECT * FROM user',   // 查询所有用户
    queryByName: 'select * from  user where username=?',  // 通过用户名索引查询用户
    queryByNamePassword: 'select * from  user where username=? and password=?',  // 通过用户名和密码索引查询用户
    insert: 'insert into user(id,username,password,nickname,identity,gender,age,createTime,updateTime) values(?,?,?,?,?,?,?,?,?)',  // 插入新用户
    updateUser: 'update user set username=?,gender=?,nickname=?,age=?,updateTime=? where id=?',// 更新用户信息
    rePassword:'update user set password=?,updateTime=? where username=?',
    deleteUser: 'delete from user where id=?', // 删除用户
    updateAdminUser:'update user set admin_select=? where id=?'
}

module.exports = userSQL
